Excel 2003 - Using Auditing Tools, Scenarios and Custom Views

      The "Excel 2003 - Using Auditing Tools, Scenarios and Custom Views" lesson covers the following topics:
  • Auditing Tools
  • Using the Scenario Manager
  • Using Custom Views
     
      Auditing Tools      
      Upon successful completion you will be able to:

1. Display the Auditing Toolbar;
2. Trace Precedents and Dependents;
3. Remove Tracer Arrows;
4. Trace Errors in Formulas;
5. Correct Formula Errors.
     
      Using the Scenario Manager      
      Upon successful completion you will be able to:

1. Name Scenario and Variable Cells;
2. Create Scenarios;
3. Select Scenario Variables;
4. Delete a Scenario;
5. Edit a Scenario;
6. Create Summary Reports.
     
      Using Custom Views      
      Upon successful completion you will be able to:

1. Define a Custom View;
2. Add a Custom View;
3. Apply a Custom View.
     
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2003 - Using Auditing Tools, Scenarios and Custom Views :
Program Training Courses - Microsoft Excel 2003 :
Office Suite Training Courses - Microsoft Office 2003 :
© 2017 Online Training Masters